package com.yjxxt.dao;

import com.yjxxt.pojo.Dept;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author Ben JiMi
 * @Date 2025/8/4 11:26
 * @Version 1.0
 */
public interface IDeptDao {
    public Dept selectByDeptno(int id);
    public Dept selectByUsernameAndPassword(@Param("username")String username, @Param("password")int  password);
    public List<Dept> findByPage(@Param("currentPage")int currentPage , @Param("pageSize")int pageSize);
   public int insert(Dept dept);
   public List<Dept> selectAll();
   public List<Dept> CountByJob();

   @Delete("delete from dept where deptno=#{deptno}")
   public int delete(int deptno);
}
